FastFDs: A Heuristic-Driven, Depth-First Algorithm for Mining Functional Dependencies from Relation Instances - Extended Abstract

Discovering functional dependencies (FDs) from an existing relation instance is an important technique in data mining and database design. To date, even the most e cient solutions are exponential in the number of attributes of the relation (n), even when the size of the output is not exponential in n. Lopes et al. developed an algorithm, Dep-Miner, that works well for large n on randomly-generated integer-valued relation instances [LPL 00a]. Dep-Miner rst reduces the FD discovery problem to that of nding minimal covers for hypergraphs, then employs a levelwise search strategy to determine these minimal covers. Our algorithm, FastFDs, instead employs a depthrst, heuristic driven search strategy for generating minimal covers of hypergraphs. This type of search is commonly used to solve search problems in Arti cial Intelligence (AI) [RN 95]. Our experimental results indicate that the levelwise strategy that is the hallmark of many successful data mining algorithms is in fact signi cantly surpassed by the depthrst, heuristic driven strategy FastFDs employs, due to the inherent space e ciency of the search. Furthermore, we revisit the comparison between Dep-Miner and Tane, including FastFDs. We report several tests on distinct benchmark relation instances, comparing the Dep-Miner and FastFDs hypergraph approaches to Tane's partitioning approach for mining FDs from a relation instance. At the end of the paper (appendix A) we provide experimental data comparing FastFDs with a third algorithm, fdep [FS 99].